Instead, you can simply select the fields that you want to see in a new PivotTable field list. 现在,您只需在新的数据透视表字段列表中选择要查看的字段即可。
To display the PivotTable Field dialog box, double-click a field button in a PivotTable. 双击数据透视表中的字段标题,即可启动数据透视表字段对话框。
PivotTable field name already exists. 已有相同数据透视表字段名存在。
The PivotTable field list is open on the right side of the screen. 在屏幕的右侧,“数据透视表字段列表”处于打开状态。
PivotTable field name is not valid. 数据透视表字段名无效。
To change the name of a PivotTable field, select the field button, and then type the new name. 如果要想改变数据透视表中字段的名称,只要选定字段按钮,直接输入新的名称即可。
Pivot fields directly on the sheet without starting the PivotTable wizard by dragging the field buttons. 要在不打开数据透视表向导的情况下直接在工作表中透视字段,应拖动字段按钮。
In the PivotTable below, I have added three fields to the row area and the sales amount field to the values area. 在数据透视表的下面,我已经添加三个字段到行区域,销售额字段添加到值区域。通常只有第一个字段的项目“年份”显示出来。
There are four areas in a PivotTable, each of which is represented by a drop zone in the field list. 在数据透视表中有四个区域,在字段列表中每一个区域代表一个拖拽区域。
Construct your PivotTable report by dragging the field buttons on the right to the diagram on the left. 将右边的字段按钮拖到左边的图上即可构造数据透视表。